package com.aijk.commons.dao;

import com.aijk.commons.dict.Dict;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * Created by iscdw on 2016/4/12.
 */
@Repository
public interface DictMapper {

    @Select("SELECT id,cid,iid, title,gbcode from sys_dictionary ")
    List<Dict> selectList();

    @Select("SELECT id,cid,iid, title,gbcode from sys_dictionary where cid = #{cid} and pid !=-1 order by sort ")
    List<Dict> selectByCid(@Param("cid") String cid);
}
